SSI Sales Data
2024-09-29
The source data contains sales transactions for a span of 48 months and comes from SSI, a Florida based B2B2C type company. The company offers custom packaging in the food industry. It offers custom branding and design as well as actual supply of the products. Customers may have transactional based sales where each order serves as it’s own agreement or customers may have a long term contract where they agree to purchase a product or several products through the course of a six month period or a year, for example. Once these agreements are established, the customer instructs it’s distributor to purchase from SSI and deliver to them. So, the purchase order, in reality comes from this distributor and not the end client.
The data available in a .csv file was read into RStudio. Below you will find the data dictionary, a Table 1 with some statistics summaries of the data and some visualizations. There are 33,818 observations and 17 variables in the data.
|
Attribute |
Format |
Description |
|---|---|---|
|
OPCO |
Varchar |
The customer placing the order. In this case, typically a Distributor. |
|
SalesOrderID |
Varchar |
Unique identifier assigned to each sales order. |
|
CustomerPO |
Varchar |
Customer’s unique identifier of their order sent to SSI |
|
Product |
Varchar |
Unique identifier assigned to each product. |
|
Description |
Varchar |
Description of the product being sold. |
|
Substrate |
Varchar |
Type of product/material. |
|
RequestedDeliveryDate |
Varchar |
Date the delivery was scheduled originally. |
|
DateFulfilled |
Varchar |
Date the delivery was made. |
|
qtyOrdered |
Numeric |
Quantity ordered on the order. |
|
qtyFulfilled |
Numeric |
Quantity delivered on the order. |
|
UnitPrice |
Numeric |
Price of each case of product SSI charges the customer. |
|
TotalPrice |
Numeric |
Total price of the sales order. |
|
Class |
Varchar |
Customer name |
|
ShipToName |
Varchar |
Address name of ordering party |
|
ShipToAddress |
Varchar |
Address where order needs to be delivered |
|
SalesOrderStatus |
Varchar |
Status of Sales order |
|
SalesItemStatus |
Varchar |
Status of each line item on the sales order |
| Total Orders | Closed Short | Fulfilled | |
|---|---|---|---|
| (n=7585) | (n=733) | (n=6852) | |
| Top Customers | |||
| Smoothie Island | 1701 (22.43%) | 455 (62.07%) | 1246 (18.18%) |
| Philly Bite | 1556 (20.51%) | 267 (36.43%) | 1289 (18.81%) |
| PlatePioneers | 1396 (18.40%) | 143 (19.51%) | 1253 (18.29%) |
| Berl Company | 906 (11.94%) | 5 (0.68%) | 901 (13.15%) |
| DineLink Intl | 589 (7.77%) | 42 (5.73%) | 547 (7.98%) |
| Top Products | |||
| DC-01 | 1135 (14.96%) | 345 (47.07%) | 790 (11.53%) |
| TSC-PQB-01 | 1087 (14.33%) | 389 (53.07%) | 698 (10.19%) |
| TSC-PW14X16-01 | 848 (11.18%) | 283 (38.61%) | 565 (8.25%) |
| CMI-PCK-01 | 802 (10.57%) | 288 (39.29%) | 514 (7.50%) |
| PC-05-B1 | 745 (9.82%) | 220 (30.01%) | 525 (7.66%) |
| Top Distributors | |||
| Ed Don & Company - Miramar | 210 (2.77%) | 0 (0.00%) | 210 (3.06%) |
| PFG- Gainesville | 197 (2.60%) | 0 (0.00%) | 197 (2.88%) |
| Ed Don & Company -Woodridge | 186 (2.45%) | 0 (0.00%) | 186 (2.71%) |
| Ed Don & Company - MiraLoma | 180 (2.37%) | 0 (0.00%) | 180 (2.63%) |
| .Ed Don - Miramar | 162 (2.14%) | 0 (0.00%) | 162 (2.36%) |
| Top Substrates | Paper | Plastic | Bagasse |
| Revenue($103,826,286) | $54,838,585 (52.82%) | $40,336,669 (38.85%) | $4,350,337 (4.19%) |
| Quantity Ordered | Min | Mean | Max |
| Total Ordered(1,971,237) | 1 | 61.47 | 23,160 |
| Unit Price | Min | Mean | Max |
| Key Stats | $0.16 | $62.60 | $864.00 |
| Total Price | Min | Mean | Max |
| Key Stats | $4.92 | $3,430.74 | $143,084.74 |